﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;

/// <summary>
/// Summary description for DAL_Leftmenu_sp
/// </summary>
public class DAL_Tintuc : clsConnection
{
    DataTable dt = new DataTable();
    public DataTable DAL_Leftmenu_tt_getData() 
    {
        try
        {
            dt = ExcuteQuery("SELECT * FROM Category WHERE Status = 1 ORDER BY type");
        }
        catch
        {

        }
        return dt;
    }
    public DataTable DAL_TT_getCalegory(int id)
    {
        try
        {
            dt = ExcuteQuery("SELECT Name FROM Category WHERE Status = 1 and Cgid = "+ id +" ORDER BY type");
        }
        catch
        {

        }
        return dt;
    }
    //public DataTable DAL_SP_getMaker()
    //{
    //    try
    //    {
    //        dt = ExcuteQuery("SELECT * FROM Maker WHERE Status = 1");
    //    }
    //    catch
    //    {

    //    }
    //    return dt;
    //}
}